package com.his.dao.jpa;

import java.math.BigDecimal;
import java.util.List;

import org.springframework.data.domain.Pageable;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;
import com.his.pojo.HisEmployee;
import com.his.pojo.HisPatient;
/*
 *住院病人信息表dao 
 */
public interface PatientDao extends CrudRepository<HisPatient, Long>{
	@Query("select p from HisPatient p order by p.brNo ")
	public List<HisPatient> findHisPatientByPage(Pageable pageable);
	
	public List<HisPatient> findByBrNameLike (String  brName);
	
	public List<HisPatient> findByYlkNo(BigDecimal ylkNo);
	
	
	
	public List<HisPatient> findByZyysNo(BigDecimal zyysNo);
	
}
